Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	23446
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	1
Duplicate rows (%)	< 0.1%
Total size in memory	2.5 MiB
Average record size in memory	112.0 B

Variable types

Categorical	1
Numeric	12

Alerts

Dataset has 1 (< 0.1%) duplicate rows	Duplicates
`chlorophyll` is highly skewed (γ1 = 51.65583126)	Skewed
`nitrate_mean` has 767 (3.3%) zeros	Zeros
`chlorophyll` has 1529 (6.5%) zeros	Zeros

Reproduction

Analysis started	2023-02-02 21:39:07.597779
Analysis finished	2023-02-02 21:39:17.550002
Duration	9.95 seconds
Software version	ydata-profiling vv4.0.0
Download configuration	config.json

siteid
Categorical

Distinct	24
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	366.3 KiB

ARIK	1096
LECO	1096
WALK	1096
SYCA	1096
PRIN	1096
Other values (19)	17966

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	93784
Distinct characters	21
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ARIK
2nd row	ARIK
3rd row	ARIK
4th row	ARIK
5th row	ARIK

Common Values

Value	Count	Frequency (%)
ARIK	1096	4.7%
LECO	1096	4.7%
WALK	1096	4.7%
SYCA	1096	4.7%
PRIN	1096	4.7%
POSE	1096	4.7%
MCRA	1096	4.7%
MCDI	1096	4.7%
MAYF	1096	4.7%
LEWI	1096	4.7%
Other values (14)	12486	53.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
arik	1096	4.7%
mayf	1096	4.7%
como	1096	4.7%
leco	1096	4.7%
king	1096	4.7%
wlou	1096	4.7%
lewi	1096	4.7%
hopb	1096	4.7%
mcdi	1096	4.7%
mcra	1096	4.7%
Other values (14)	12486	53.3%

Most occurring characters

Value	Count	Frequency (%)
C	8547	9.1%
I	7767	8.3%
E	7644	8.2%
L	7012	7.5%
O	6968	7.4%
A	6922	7.4%
R	6837	7.3%
M	5451	5.8%
B	4692	5.0%
P	4247	4.5%
Other values (11)	27697	29.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	93784	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	8547	9.1%
I	7767	8.3%
E	7644	8.2%
L	7012	7.5%
O	6968	7.4%
A	6922	7.4%
R	6837	7.3%
M	5451	5.8%
B	4692	5.0%
P	4247	4.5%
Other values (11)	27697	29.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	93784	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	8547	9.1%
I	7767	8.3%
E	7644	8.2%
L	7012	7.5%
O	6968	7.4%
A	6922	7.4%
R	6837	7.3%
M	5451	5.8%
B	4692	5.0%
P	4247	4.5%
Other values (11)	27697	29.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	93784	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
C	8547	9.1%
I	7767	8.3%
E	7644	8.2%
L	7012	7.5%
O	6968	7.4%
A	6922	7.4%
R	6837	7.3%
M	5451	5.8%
B	4692	5.0%
P	4247	4.5%
Other values (11)	27697	29.5%

nitrate_mean
Real number (ℝ)

Distinct	11109
Distinct (%)	47.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22.413306

Minimum	0
Maximum	851.7
Zeros	767
Zeros (%)	3.3%
Negative	0
Negative (%)	0.0%
Memory size	366.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0.32083333
Q1	2.7708333
median	6.1
Q3	21.471615
95-th percentile	169.37135
Maximum	851.7
Range	851.7
Interquartile range (IQR)	18.700781

Descriptive statistics

Standard deviation	45.372328
Coefficient of variation (CV)	2.0243478
Kurtosis	14.711481
Mean	22.413306
Median Absolute Deviation (MAD)	4.7177083
Skewness	3.4880563
Sum	525502.38
Variance	2058.6481
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	767	3.3%
3.3	33	0.1%
6.1	32	0.1%
3.55	32	0.1%
3.633333333	29	0.1%
3.65	29	0.1%
2.75	29	0.1%
3.14375	27	0.1%
4.55	26	0.1%
2.652083333	25	0.1%
Other values (11099)	22417	95.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	767	3.3%
0.001041666667	1	< 0.1%
0.002222222222	1	< 0.1%
0.003333333333	1	< 0.1%
0.007291666667	1	< 0.1%
0.008333333333	1	< 0.1%
0.00989010989	1	< 0.1%
0.01041666667	1	< 0.1%
0.01136363636	1	< 0.1%
0.01354166667	3	< 0.1%

Value	Count	Frequency (%)
851.7	1	< 0.1%
493.6	1	< 0.1%
284.4541667	1	< 0.1%
264.3375	1	< 0.1%
261.76875	1	< 0.1%
261.3	1	< 0.1%
260.85625	1	< 0.1%
260.5569231	1	< 0.1%
259.7614583	1	< 0.1%
259.6916667	1	< 0.1%

specific_conductance
Real number (ℝ)

Distinct	19471
Distinct (%)	83.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	583.87356

Minimum	6.25 × 10^-5
Maximum	215585.2
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	366.3 KiB

Quantile statistics

Minimum	6.25 × 10^-5
5-th percentile	13.48777
Q1	37.768763
median	117.8826
Q3	508.94584
95-th percentile	685.11138
Maximum	215585.2
Range	215585.2
Interquartile range (IQR)	471.17707

Descriptive statistics

Standard deviation	6249.5379
Coefficient of variation (CV)	10.703581
Kurtosis	383.47817
Mean	583.87356
Median Absolute Deviation (MAD)	98.911444
Skewness	19.25644
Sum	13689500
Variance	39056724
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
573.7750452	11	< 0.1%
34.77873521	11	< 0.1%
39.03122434	10	< 0.1%
37.93636806	10	< 0.1%
38.13544444	9	< 0.1%
466.7478697	9	< 0.1%
652.2436736	9	< 0.1%
38.02676389	9	< 0.1%
206.4707743	9	< 0.1%
111.3831285	9	< 0.1%
Other values (19461)	23350	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6.25 × 10^-5	1	< 0.1%
0.001541666667	1	< 0.1%
0.005796852077	1	< 0.1%
0.00871438499	1	< 0.1%
0.01110923771	1	< 0.1%
0.01912358986	1	< 0.1%
0.02366180362	1	< 0.1%
0.02713880685	1	< 0.1%
0.02773611111	1	< 0.1%
0.02871527778	1	< 0.1%

Value	Count	Frequency (%)
215585.1969	1	< 0.1%
118086.5914	1	< 0.1%
118034.1458	1	< 0.1%
118032.4041	1	< 0.1%
118026.3421	1	< 0.1%
118017.1726	1	< 0.1%
118014.5285	1	< 0.1%
118010.4898	1	< 0.1%
118006.4988	6	< 0.1%
118001.9287	6	< 0.1%

DO
Real number (ℝ)

Distinct	19409
Distinct (%)	82.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.483089

Minimum	0
Maximum	354.97759
Zeros	3
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	366.3 KiB

Quantile statistics

Minimum	0
5-th percentile	4.6670184
Q1	8.2260217
median	9.6660955
Q3	11.095766
95-th percentile	13.169993
Maximum	354.97759
Range	354.97759
Interquartile range (IQR)	2.869744

Descriptive statistics

Standard deviation	16.81019
Coefficient of variation (CV)	1.6035532
Kurtosis	296.20879
Mean	10.483089
Median Absolute Deviation (MAD)	1.4369149
Skewness	16.943946
Sum	245786.49
Variance	282.58249
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8.708430556	11	< 0.1%
12.08062847	10	< 0.1%
9.987256944	10	< 0.1%
8.924236111	9	< 0.1%
8.059923611	9	< 0.1%
9.389659722	9	< 0.1%
7.731243056	9	< 0.1%
4.162380764	9	< 0.1%
3.218755378	9	< 0.1%
8.680909722	9	< 0.1%
Other values (19399)	23352	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3	< 0.1%
0.2234930556	1	< 0.1%
0.2289583333	1	< 0.1%
0.2346944444	1	< 0.1%
0.535875	1	< 0.1%
0.5426909722	1	< 0.1%
0.5442743056	1	< 0.1%
0.5455208333	1	< 0.1%
0.5476666667	1	< 0.1%
0.5570833333	1	< 0.1%

Value	Count	Frequency (%)
354.9775903	1	< 0.1%
350.844588	1	< 0.1%
350.2903487	1	< 0.1%
348.9448664	5	< 0.1%
345.6860347	1	< 0.1%
344.8827361	1	< 0.1%
344.8493507	4	< 0.1%
343.2838435	1	< 0.1%
342.7693021	1	< 0.1%
339.5286148	1	< 0.1%

pH
Real number (ℝ)

Distinct	19078
Distinct (%)	81.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.5137891

Minimum	0.0025
Maximum	13.790451
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	366.3 KiB

Quantile statistics

Minimum	0.0025
5-th percentile	5.7870911
Q1	7.1478749
median	7.6311563
Q3	7.9749115
95-th percentile	8.3077426
Maximum	13.790451
Range	13.787951
Interquartile range (IQR)	0.8270366

Descriptive statistics

Standard deviation	0.87651541
Coefficient of variation (CV)	0.11665425
Kurtosis	12.338036
Mean	7.5137891
Median Absolute Deviation (MAD)	0.40040672
Skewness	-0.19135221
Sum	176168.3
Variance	0.76827926
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7.960267361	11	< 0.1%
7.9386875	10	< 0.1%
7.701305556	10	< 0.1%
8.078440972	10	< 0.1%
9.183684028	10	< 0.1%
6.944145833	10	< 0.1%
7.885038194	9	< 0.1%
7.507246528	9	< 0.1%
7.674159722	9	< 0.1%
7.505371528	9	< 0.1%
Other values (19068)	23349	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0025	1	< 0.1%
0.02	1	< 0.1%
0.04	3	< 0.1%
0.04670833333	1	< 0.1%
0.06	2	< 0.1%
0.0805625	1	< 0.1%
0.09507638889	1	< 0.1%
0.09948611111	1	< 0.1%
0.1049166667	1	< 0.1%
0.1092361111	1	< 0.1%

Value	Count	Frequency (%)
13.79045139	1	< 0.1%
13.68230208	1	< 0.1%
13.60482168	1	< 0.1%
13.50673628	1	< 0.1%
13.49504167	1	< 0.1%
13.47515278	1	< 0.1%
13.45948958	1	< 0.1%
13.41638647	1	< 0.1%
13.37937153	1	< 0.1%
13.36761084	1	< 0.1%

chlorophyll
Real number (ℝ)

SKEWED ZEROS

Distinct	18271
Distinct (%)	77.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	39.532824

Minimum	0
Maximum	59462.899
Zeros	1529
Zeros (%)	6.5%
Negative	0
Negative (%)	0.0%
Memory size	366.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.46566319
median	1.2444427
Q3	4.2930165
95-th percentile	102.89022
Maximum	59462.899
Range	59462.899
Interquartile range (IQR)	3.8273533

Descriptive statistics

Standard deviation	930.88464
Coefficient of variation (CV)	23.547133
Kurtosis	2866.5414
Mean	39.532824
Median Absolute Deviation (MAD)	1.043849
Skewness	51.655831
Sum	926886.58
Variance	866546.21
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1529	6.5%
2.829520833	10	< 0.1%
1.342516154	10	< 0.1%
0.7168263889	9	< 0.1%
5.652826389	9	< 0.1%
8.596649306	9	< 0.1%
0.7444097222	9	< 0.1%
29.24377083	8	< 0.1%
2.651560881	8	< 0.1%
1.154545139	8	< 0.1%
Other values (18261)	21837	93.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1529	6.5%
0.0009201388889	1	< 0.1%
0.0009513888889	1	< 0.1%
0.001169544893	1	< 0.1%
0.001333984445	1	< 0.1%
0.001489583333	1	< 0.1%
0.001690751445	1	< 0.1%
0.001847222222	1	< 0.1%
0.002135416667	1	< 0.1%
0.002392361111	1	< 0.1%

Value	Count	Frequency (%)
59462.8986	1	< 0.1%
58945.07041	1	< 0.1%
54365.8061	1	< 0.1%
53169.06921	1	< 0.1%
47121.93829	1	< 0.1%
35084.85759	1	< 0.1%
31630.10413	1	< 0.1%
27480.42869	1	< 0.1%
26948.5032	1	< 0.1%
25381.5971	1	< 0.1%

turbidity
Real number (ℝ)

Distinct	14734
Distinct (%)	62.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.8006177

Minimum	0
Maximum	99.988639
Zeros	9
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	366.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0.31123611
Q1	1.0980454
median	2.683687
Q3	9.5134653
95-th percentile	47.898694
Maximum	99.988639
Range	99.988639
Interquartile range (IQR)	8.4154199

Descriptive statistics

Standard deviation	16.964078
Coefficient of variation (CV)	1.7309192
Kurtosis	8.9260767
Mean	9.8006177
Median Absolute Deviation (MAD)	2.1232321
Skewness	2.9105889
Sum	229785.28
Variance	287.77994
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6.307083333	20	0.1%
11.51238194	19	0.1%
6.210263889	19	0.1%
78.25515278	19	0.1%
6.770125	18	0.1%
2.968525281	18	0.1%
51.03280556	18	0.1%
18.27320833	18	0.1%
9.185739583	18	0.1%
1.348585823	18	0.1%
Other values (14724)	23261	99.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	9	< 0.1%
0.0001319444444	1	< 0.1%
0.0005158678381	1	< 0.1%
0.001059459694	1	< 0.1%
0.001180555556	1	< 0.1%
0.001286269279	1	< 0.1%
0.002308008809	1	< 0.1%
0.003083333333	1	< 0.1%
0.003191978547	1	< 0.1%
0.003732638889	1	< 0.1%

Value	Count	Frequency (%)
99.98863889	1	< 0.1%
99.89586806	1	< 0.1%
99.87997851	1	< 0.1%
99.85890278	1	< 0.1%
99.46018056	1	< 0.1%
99.44445139	6	< 0.1%
99.37908333	1	< 0.1%
99.35345486	1	< 0.1%
99.07136458	1	< 0.1%
98.91891262	1	< 0.1%

fDOM
Real number (ℝ)

Distinct	16179
Distinct (%)	69.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	27.379228

Minimum	0.0016666667
Maximum	298.34492
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	366.3 KiB

Quantile statistics

Minimum	0.0016666667
5-th percentile	1.184276
Q1	5.9634218
median	15.809764
Q3	35.193319
95-th percentile	88.596172
Maximum	298.34492
Range	298.34326
Interquartile range (IQR)	29.229898

Descriptive statistics

Standard deviation	34.655744
Coefficient of variation (CV)	1.2657678
Kurtosis	12.715532
Mean	27.379228
Median Absolute Deviation (MAD)	11.616319
Skewness	3.0377977
Sum	641933.38
Variance	1201.0206
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15.45	22	0.1%
45.22	19	0.1%
27.7235625	14	0.1%
1.601944444	14	0.1%
15.12207447	14	0.1%
25.38077778	14	0.1%
20.45387955	14	0.1%
109.2923125	13	0.1%
13.39816667	13	0.1%
0.4514305556	13	0.1%
Other values (16169)	23296	99.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.001666666667	1	< 0.1%
0.001807628524	1	< 0.1%
0.00725	1	< 0.1%
0.009034722222	1	< 0.1%
0.009215277778	1	< 0.1%
0.01093055556	1	< 0.1%
0.01320138889	11	< 0.1%
0.01429861111	1	< 0.1%
0.01854861111	1	< 0.1%
0.01926388889	1	< 0.1%

Value	Count	Frequency (%)
298.3449236	1	< 0.1%
295.7704514	1	< 0.1%
295.0840134	1	< 0.1%
292.856303	1	< 0.1%
291.973625	9	< 0.1%
287.3111135	1	< 0.1%
284.1592708	1	< 0.1%
283.9141528	1	< 0.1%
283.8414861	1	< 0.1%
283.0132083	1	< 0.1%

mean_temp
Real number (ℝ)

Distinct	17328
Distinct (%)	73.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.89726

Minimum	1.9013284
Maximum	31.721088
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	366.3 KiB

Quantile statistics

Minimum	1.9013284
5-th percentile	3.2524922
Q1	7.109186
median	12.124423
Q3	18.377882
95-th percentile	23.883193
Maximum	31.721088
Range	29.819759
Interquartile range (IQR)	11.268696

Descriptive statistics

Standard deviation	6.7680836
Coefficient of variation (CV)	0.52476911
Kurtosis	-1.0284933
Mean	12.89726
Median Absolute Deviation (MAD)	5.5913361
Skewness	0.26025395
Sum	302389.16
Variance	45.806956
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.302480655	49	0.2%
4.348202381	12	0.1%
16.21949648	12	0.1%
3.839376488	12	0.1%
10.03405655	12	0.1%
21.83341964	12	0.1%
7.926578656	12	0.1%
9.31	12	0.1%
4.677092458	12	0.1%
11.32598958	12	0.1%
Other values (17318)	23289	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.901328383	1	< 0.1%
1.903630952	1	< 0.1%
1.911272321	1	< 0.1%
1.911690476	1	< 0.1%
1.911869048	1	< 0.1%
1.912936012	1	< 0.1%
1.913133929	1	< 0.1%
1.916729167	1	< 0.1%
1.917998512	6	< 0.1%
1.920572917	1	< 0.1%

Value	Count	Frequency (%)
31.7210878	1	< 0.1%
31.24484673	1	< 0.1%
31.05685565	1	< 0.1%
31.03692708	1	< 0.1%
30.89431548	1	< 0.1%
30.84168155	1	< 0.1%
30.71561905	1	< 0.1%
30.71248214	1	< 0.1%
30.58959821	1	< 0.1%
30.57940774	1	< 0.1%

CH4_conc
Real number (ℝ)

Distinct	733
Distinct (%)	3.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16.588224

Minimum	1.3109407
Maximum	1121.0379
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	366.3 KiB

Quantile statistics

Minimum	1.3109407
5-th percentile	1.7898706
Q1	2.2888922
median	2.9568271
Q3	6.5429576
95-th percentile	46.94904
Maximum	1121.0379
Range	1119.727
Interquartile range (IQR)	4.2540654

Descriptive statistics

Standard deviation	79.515231
Coefficient of variation (CV)	4.7934748
Kurtosis	143.0286
Mean	16.588224
Median Absolute Deviation (MAD)	0.9100072
Skewness	11.210174
Sum	388927.49
Variance	6322.672
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14.60143328	80	0.3%
3.71680165	80	0.3%
2.658842758	80	0.3%
2.512820683	70	0.3%
2.363340225	67	0.3%
1.7453277	55	0.2%
2.34971865	55	0.2%
1121.0379	54	0.2%
19.9759255	51	0.2%
1.74231325	51	0.2%
Other values (723)	22803	97.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.310940717	32	0.1%
1.34711825	33	0.1%
1.347839808	35	0.1%
1.36316455	31	0.1%
1.457755	30	0.1%
1.478376767	35	0.1%
1.517455375	39	0.2%
1.534133375	37	0.2%
1.56372325	43	0.2%
1.569164775	31	0.1%

Value	Count	Frequency (%)
1121.0379	54	0.2%
1099.988239	38	0.2%
507.196405	31	0.1%
406.1683071	31	0.1%
359.0325085	31	0.1%
348.6181527	31	0.1%
327.7892796	31	0.1%
292.5923172	30	0.1%
278.9625211	30	0.1%
272.9822939	31	0.1%

CO2_conc
Real number (ℝ)

Distinct	733
Distinct (%)	3.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1303.4592

Minimum	451.65826
Maximum	11310.682
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	366.3 KiB

Quantile statistics

Minimum	451.65826
5-th percentile	607.96726
Q1	740.02833
median	925.39724
Q3	1308.5466
95-th percentile	3981.2353
Maximum	11310.682
Range	10859.024
Interquartile range (IQR)	568.51831

Descriptive statistics

Standard deviation	1173.8768
Coefficient of variation (CV)	0.90058574
Kurtosis	17.864518
Mean	1303.4592
Median Absolute Deviation (MAD)	230.10609
Skewness	3.7830308
Sum	30560905
Variance	1377986.7
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1999.974753	80	0.3%
652.4161503	80	0.3%
921.5851002	80	0.3%
628.4179888	70	0.3%
675.6038126	67	0.3%
1030.656109	55	0.2%
726.9184898	55	0.2%
4111.138738	54	0.2%
1376.575813	51	0.2%
846.5851382	51	0.2%
Other values (723)	22803	97.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
451.658259	31	0.1%
468.3741605	30	0.1%
488.551533	33	0.1%
511.0961165	30	0.1%
517.5393612	36	0.2%
523.3695863	35	0.1%
530.5988639	31	0.1%
537.6745123	31	0.1%
538.5238653	30	0.1%
539.3033726	34	0.1%

Value	Count	Frequency (%)
11310.68249	34	0.1%
8602.955041	29	0.1%
8470.422789	30	0.1%
7771.652797	32	0.1%
7545.073112	32	0.1%
7353.3547	40	0.2%
7223.292009	43	0.2%
6719.990008	30	0.1%
6232.460603	31	0.1%
6007.864268	31	0.1%

N2O_conc
Real number (ℝ)

Distinct	733
Distinct (%)	3.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.64399083

Minimum	0.22668198
Maximum	17.283047
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	366.3 KiB

Quantile statistics

Minimum	0.22668198
5-th percentile	0.36388555
Q1	0.4552329
median	0.55103137
Q3	0.68916245
95-th percentile	1.0130376
Maximum	17.283047
Range	17.056366
Interquartile range (IQR)	0.23392955

Descriptive statistics

Standard deviation	0.77868384
Coefficient of variation (CV)	1.2091536
Kurtosis	320.71324
Mean	0.64399083
Median Absolute Deviation (MAD)	0.11167857
Skewness	16.694549
Sum	15099.009
Variance	0.60634852
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.9247087083	80	0.3%
0.721567075	80	0.3%
0.6338136583	80	0.3%
0.78556025	70	0.3%
0.62038335	67	0.3%
0.8191546	55	0.2%
0.5856849625	55	0.2%
0.761729675	54	0.2%
0.49425745	51	0.2%
0.4826633	51	0.2%
Other values (723)	22803	97.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.226681975	40	0.2%
0.2495983375	34	0.1%
0.2542558375	31	0.1%
0.2703872	8	< 0.1%
0.2727544	32	0.1%
0.2744453444	39	0.2%
0.2811430167	24	0.1%
0.2830501167	31	0.1%
0.28345535	30	0.1%
0.2839153167	23	0.1%

Value	Count	Frequency (%)
17.2830475	31	0.1%
11.27185817	30	0.1%
6.1993433	31	0.1%
2.70986205	33	0.1%
2.41977485	30	0.1%
1.997072	33	0.1%
1.675499875	30	0.1%
1.54271025	31	0.1%
1.42676645	31	0.1%
1.384639	29	0.1%

Microbialabundanceper_ml
Real number (ℝ)

Distinct	635
Distinct (%)	2.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2469686

Minimum	4548.8889
Maximum	62606310
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	366.3 KiB

Quantile statistics

Minimum	4548.8889
5-th percentile	46090
Q1	162276.67
median	328395.56
Q3	1115775.6
95-th percentile	14852501
Maximum	62606310
Range	62601761
Interquartile range (IQR)	953498.89

Descriptive statistics

Standard deviation	6659992.6
Coefficient of variation (CV)	2.6966961
Kurtosis	32.50246
Mean	2469686
Median Absolute Deviation (MAD)	234294.44
Skewness	5.0595365
Sum	5.7904257 × 10¹⁰
Variance	4.4355502 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
295747.7778	193	0.8%
1281893.333	148	0.6%
165637.7778	139	0.6%
75857.77778	119	0.5%
332715.5556	110	0.5%
1223800	110	0.5%
593895.5556	102	0.4%
458984.4444	99	0.4%
320713.3333	95	0.4%
2596957.778	94	0.4%
Other values (625)	22237	94.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4548.888889	37	0.2%
9002.222222	39	0.2%
9048.888889	35	0.1%
12447.77778	33	0.1%
12975.55556	44	0.2%
13443.33333	31	0.1%
14207.77778	43	0.2%
16585.55556	35	0.1%
17764.44444	31	0.1%
19081.11111	37	0.2%

Value	Count	Frequency (%)
62606310	33	0.1%
61982167.78	31	0.1%
59389574.44	40	0.2%
39993141.11	33	0.1%
39849108.89	30	0.1%
39465021.11	32	0.1%
35361682.22	33	0.1%
32692272.22	33	0.1%
32397805.56	33	0.1%
30390946.67	31	0.1%

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	siteid	nitrate_mean	specific_conductance	DO	pH	chlorophyll	turbidity	fDOM	mean_temp	CH4_conc	CO2_conc	N2O_conc	Microbialabundanceper_ml
date
2018-01-01	ARIK	13.700000	539.059444	10.186389	7.822500	2.095000	2.899444	45.220000	2.302481	25.792847	1621.722701	0.491186	52674.444444
2018-01-02	ARIK	13.700000	539.059444	10.186389	7.822500	2.095000	2.899444	45.220000	2.302481	25.792847	1621.722701	0.491186	52674.444444
2018-01-03	ARIK	13.700000	539.059444	10.186389	7.822500	2.095000	2.899444	45.220000	2.302481	25.792847	1621.722701	0.491186	52674.444444
2018-01-04	ARIK	12.535417	546.480042	9.921785	7.812403	3.249465	60.369840	45.220000	2.302481	25.792847	1621.722701	0.491186	52674.444444
2018-01-05	ARIK	10.310417	550.830208	9.721729	7.826743	5.565236	2.548007	45.220000	2.302481	25.792847	1621.722701	0.491186	52674.444444
2018-01-06	ARIK	9.966667	535.343569	10.060528	7.839222	8.422056	33.219167	45.220000	2.302481	25.792847	1621.722701	0.491186	52674.444444
2018-01-07	ARIK	9.207292	503.494465	10.333701	7.883479	9.204167	3.417035	45.220000	2.302481	25.792847	1621.722701	0.491186	52674.444444
2018-01-08	ARIK	8.103125	486.388582	10.645000	7.909354	12.090326	19.399326	45.220000	2.302481	25.792847	1621.722701	0.491186	52674.444444
2018-01-09	ARIK	7.708333	475.402592	10.650715	7.929910	43.929736	4.278028	17.590000	2.302481	25.792847	1621.722701	0.491186	52674.444444
2018-01-10	ARIK	6.932292	467.588493	10.577743	7.947944	30.268646	11.884910	0.451431	2.302481	25.792847	1621.722701	0.491186	52674.444444

	siteid	nitrate_mean	specific_conductance	DO	pH	chlorophyll	turbidity	fDOM	mean_temp	CH4_conc	CO2_conc	N2O_conc	Microbialabundanceper_ml
date
2020-12-22	WLOU	3.808333	110.893983	10.414507	8.093003	1.344167	1.889278	4.581035	15.160753	2.807956	805.804145	0.725995	54252.222222
2020-12-23	WLOU	3.822917	111.120556	10.408309	8.104146	0.989441	4.469233	4.638299	19.059426	2.807956	805.804145	0.725995	54252.222222
2020-12-24	WLOU	3.650000	111.481869	10.495976	8.103500	0.928238	2.389750	4.518500	7.926579	2.807956	805.804145	0.725995	54252.222222
2020-12-25	WLOU	54.902083	68.811199	10.619208	7.344299	2.661920	0.340674	27.655264	4.480490	2.807956	805.804145	0.725995	54252.222222
2020-12-26	WLOU	27.848958	630.318368	11.733611	7.820493	0.254809	0.722101	8.416081	21.252603	2.807956	805.804145	0.725995	54252.222222
2020-12-27	WLOU	0.000000	298.291892	11.899740	8.146028	0.220042	0.959097	16.215236	17.389786	2.807956	805.804145	0.725995	54252.222222
2020-12-28	WLOU	0.041758	12.105146	8.384253	6.651626	0.900684	2.639976	31.655028	10.173146	2.807956	805.804145	0.725995	54252.222222
2020-12-29	WLOU	4.188542	613.853512	10.900608	7.869108	9.817500	0.600420	4.082917	4.325874	2.807956	805.804145	0.725995	54252.222222
2020-12-30	WLOU	54.432292	176.735399	14.561951	7.948806	1.642281	2.160620	142.774583	3.839376	2.807956	805.804145	0.725995	54252.222222
2020-12-31	WLOU	54.080208	11.799757	12.442292	7.611872	10.631253	0.668552	54.251333	8.364247	2.807956	805.804145	0.725995	54252.222222

Most frequently occurring

	siteid	nitrate_mean	specific_conductance	DO	pH	chlorophyll	turbidity	fDOM	mean_temp	CH4_conc	CO2_conc	N2O_conc	Microbialabundanceper_ml	# duplicates
0	ARIK	13.7	539.059444	10.186389	7.8225	2.095	2.899444	45.22	2.302481	25.792847	1621.722701	0.491186	52674.444444	3

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Missing values

Sample

Duplicate rows

Most frequently occurring